# -*- coding: utf-8 -*-
"""
插入与教练数据有关的数据表的SQL语句。
"""

# 1
insert_coach_brief_introduction = """
INSERT INTO coach_brief_introduction(
bi_name,
bi_birthday,
bi_hometown,
bi_highschool,
bi_university,
bi_teaching_career,
bi_season,
bi_playoff,
bi_finals,
bi_champion,
bi_best_coach,
bi_hall_of_fame
)
VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)
"""

# 2
insert_coach_season_data = """
INSERT INTO coach_season_data(
sd_name,
sd_season,
sd_team,
sd_teaching,
sd_shot,
sd_shothit,
sd_shotto,
sd_threepoints,
sd_tphit,
sd_tpshot,
sd_penalty,
sd_phit,
sd_pshot,
sd_backboard,
sd_bbfront,
sd_bbback,
sd_assist,
sd_steal,
sd_cap,
sd_mistake,
sd_foul,
sd_score,
sd_win,
sd_negative,
sd_winning_probability
)
VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)
"""

# 3
insert_coach_season_data_count = """
INSERT INTO coach_season_data_count(
sdc_name,
sdc_teaching_career,
sdc_teaching_team,
sdc_teaching,
sdc_shot,
sdc_shothit,
sdc_shotto,
sdc_threepoints,
sdc_tphit,
sdc_tpshot,
sdc_penalty,
sdc_phit,
sdc_pshot,
sdc_backboard,
sdc_bbfront,
sdc_bbback,
sdc_assist,
sdc_steal,
sdc_cap,
sdc_mistake,
sdc_foul,
sdc_score,
sdc_win,
sdc_negative,
sdc_winning_probability
)
VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)
"""

# 4
insert_coach_playoff_data = """
INSERT INTO coach_playoff_data(
pd_name,
pd_season,
pd_team,
pd_teaching,
pd_shot,
pd_shothit,
pd_shotto,
pd_threepoints,
pd_tphit,
pd_tpshot,
pd_penalty,
pd_phit,
pd_pshot,
pd_backboard,
pd_bbfront,
pd_bbback,
pd_assist,
pd_steal,
pd_cap,
pd_mistake,
pd_foul,
pd_score,
pd_win,
pd_negative,
pd_winning_probability
)
VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)
"""

# 5
insert_coach_playoff_data_count = """
INSERT INTO coach_playoff_data_count(
pdc_name,
pdc_teaching_career,
pdc_teaching_team,
pdc_teaching,
pdc_shot,
pdc_shothit,
pdc_shotto,
pdc_threepoints,
pdc_tphit,
pdc_tpshot,
pdc_penalty,
pdc_phit,
pdc_pshot,
pdc_backboard,
pdc_bbfront,
pdc_bbback,
pdc_assist,
pdc_steal,
pdc_cap,
pdc_mistake,
pdc_foul,
pdc_score,
pdc_win,
pdc_negative,
pdc_winning_probability
)
VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)
 """
